Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DBA_ADVISOR_SQLW_TEMPLATES

`DBA_ADVISOR_SQLW_TEMPLATES` displays an aggregated picture of all SQLWkld template objects in the database.

Related View

`USER_ADVISOR_SQLW_TEMPLATES` displays an aggregated picture of the SQLWkld template objects owned by the current user. This view does not display the `OWNER` column.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR2(30)` |  | Owner of the workload object
`WORKLOAD_ID` | `NUMBER` | `NOT NULL` | Unique identifier number of the workload object
`WORKLOAD_NAME` | `VARCHAR2(30)` |  | Unique name of the workload
`DESCRIPTION` | `VARCHAR2(256)` |  | User-specified description of the workload
`CREATE_DATE` | `DATE` | `NOT NULL` | Date on which the workload object was created
`MODIFY_DATE` | `DATE` | `NOT NULL` | Date of last update to the current workload
`SOURCE` | `VARCHAR2(30)` |  | Optional object or template on which the object was based
`READ_ONLY` | `VARCHAR2(5)` |  | Indicates whether the workload template can be modified or deleted (`TRUE`) or not (`FALSE`)

See Also: "USER_ADVISOR_SQLW_TEMPLATES"